<%@ page import="java.util.List" %>
<%@ page import="java.util.ArrayList" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.DriverManager" %><%--
  Created by IntelliJ IDEA.
  User: 美美美
  Date: 2018/3/20
  Time: 15:45
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
  <head>
    <title></title>
  </head>
  <body>

  <%
    if( session.getAttribute("islogin") == null){
        //没有登录跳转到login 界面
        response .sendRedirect("login.jsp");
    }
  %>

  <%
    out.write("hello world");
    out.write("<h1>hello</h1>");
  %>

  <style type="text/css">
    table{
      border:1px solid #000;
      border-collapse:collapse;
    }

    td,th{
      border: 1px solid #000;
      border-collapse:collapse;
    }
  </style>

  <table>
    <thead>
    <tr>
      <th>编号</th>
      <th>姓名</th>
      <th>密码</th>
    </tr>
    </thead>


    <tbody>

    <%

      class User {
        int id;
        String name;
        String password;
        //alt+insert
        public User(int id,String name,String password){
            this.id = id;
            this.name = name;
            this.password = password;//面向对象的三个特征：封装，继承，多态，这是封装
        }
      }

      List<User> userList = new ArrayList<User>();
//      list.add(new User(1,"wu","123"));
//      list.add(new User(2,"li","234"));
//      list.add(new User(3,"han","456"));
//      或
//      User chen = new User();
//      chen.id = 1;
//      chen.name = "wu";
//      chen.password = "12323";
//      userList.add(chen);

      //3+1
      Connection connection = null;
      Statement statement = null;
      ResultSet resultSet = null;

      String sql ="select * from t_user";

      Class.forName("com.mysql.jdbc.Driver");//加载驱动程序（必须）

      connection = DriverManager.getConnection(
              "jdbc:mysql://localhost:3306/sctu_javaweb_2018?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT",
              //localhost表示是哪一台机器，如果是别的电脑就用别的电脑的IP
              //sctu_...是数据库名
              //问号后面的是
              //404的问题是找不到，证明文件名可能出错了
              //500的问题在某行出错了。。。ctrl+N，Alt+F1
              "root",
              "251807680wmh"
      );

      statement = connection.createStatement();
      resultSet = statement.executeQuery(sql);

      while (resultSet.next()){

          int id = resultSet.getInt(1);
          String username = resultSet.getString(2);
          String password = resultSet.getString(3);

          User user = new User(id,username,password);
          userList.add(user);
      }
      resultSet.close();
      statement.close();
      connection.close();

      for(User user:userList){
        out.write("<tr><td>"+user.id+"</td><td>"+user.name+"</td><td>" +user.password+
                "</td><td><a href='deleteUserHandler.jsp?id=" + user.id + "'>删除</a></td>" +
                "<td><a href='updateUser.jsp?id=" + user.id + "&username=" + user.name +
                "&password=" + user.password + "'>更新</a></td></tr>");
      }


      //221替换原则（两个""中间两个++中间一个数据）

//      for (int i = 0; i < 10; i++) {
//          //alt+shift+向上箭头
//        //ctrl+alt+l整理代码
//        out.write("<tr><td>"+i+"</td><td>吴</td><td>123</td></tr>");
//
//      }
    %>
    </tbody>

  </table>

  <p><a href="addUser.jsp">添加用户</a></p>

  <!--静态信息-->
  <%@ include file= "footer.jsp" %>

  <!--jsp 前缀   动态信息-->
  <jsp:include page="footer.jsp">
    <jsp:param name="year" value="2018"/>
  </jsp:include>

  </body>
</html>
